Overview: Aggregate

An aggregate refers to mathematical operations performed on a group of numbers, such as finding the average value, the standard deviation and row count, for example. In this operation, selected available double, integer or string fields are used for grouping, and then the required aggregate operation is performed on fields selected by the user during configuration.

Understanding grouping and aggregation

Properties

Category:	Transform
Performance risk:	Low performance risk
Knowledge required:	None

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	Yes
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	No

Requirements

A dataset that contains at least one double, integer or string field to group by, and one or more fields to aggregate.
Note:
- You cannot select aggregates over the field used for grouping.
- You cannot apply the same aggregation twice on the same field.

Results

A new dataset is created, listing the fields you grouped by, and all the aggregations performed on the selected fields.